﻿CREATE TABLE [dbo].[arhRezultatPatrimonial] (
    [row]        INT          NOT NULL,
    [nr_rand]    TEXT         NOT NULL,
    [text]       TEXT         NOT NULL,
    [codfix]     INT          NOT NULL,
    [cod]        VARCHAR (10) NOT NULL,
    [coltypei]   CHAR (1)     NOT NULL,
    [soldi]      TEXT         NOT NULL,
    [coltypef]   CHAR (1)     NOT NULL,
    [soldf]      TEXT         NOT NULL,
    [eval]       INT          NOT NULL,
    [CodUnitate] SMALLINT     DEFAULT ((0)) NOT NULL,
    [Boldat]     BIT          DEFAULT ((0)) NOT NULL,
    [An]         SMALLINT     DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_arhRezultatPatrimonial] PRIMARY KEY CLUSTERED ([row] ASC),
    CONSTRAINT [FK_arhRezultatPatrimonial_Unitati] FOREIGN KEY ([CodUnitate]) REFERENCES [dbo].[Unitati] ([CodUnitate])
);

